2012-09-04 - 4911.100 - Spec - Shipped Order by Sales Rep and Cust #CrystalReportDevelopment
SPECIFICATIONS
4911.100 - Shipped order by sales rep and cust
Requirement Summary
To move the SH100(Shipped order by sales rep and customer) report from NEP Source to NBP source.
Admin Info
Title
|
SH100 - Shipped order by sales rep and cust
|
Requested By
|
Mark Harris
|
Spec Created By
|
Mallareddy D
|
Spec Created Date
|
04/16/2013
|
Spec QA by
|
Uday Kumar P
|
Objects
|
SH100
|
Document Status
|
Complete
|
References
Prior Tickets
4674.600 - BW Performance
4674.700 - BW Performance
Documents
Infoset ZSD_SHIPPED.doc
Functional Requirement
Need to change the SH100 report source from NEP infoset to SAP BW BEx query and validate both versions.
Solution Summary
Currently the SH100 report is using NEP Infoset and that is being updated with SAP BEX query ZIC_SHIP_Q001 based on the new shipped infocube in BW.
Test Plan
SNo
|
Test Scenario
|
Expected Results
|
1
|
New Report values in NBP need to be compared with Existing Production Report in NEP
|
Values should be identical
|
Solution Details
The ECC Fileds that are currently used in SH100 report is updated with the corresponding BW Fileds which are shown in table below using the ZIC_SHIP_Q001 BEx query:
SNo
|
ECC Field
|
BW Field
|
1
|
TEXT_VBAK_KUNNR (Sold-to-party)
|
0SOLD_TO (Sold-to party)
|
2
|
TEXT_VBAP_MATNR (Material Number)
|
0MATERIAL (Material)
|
3
|
LIKP_BOLNR (Bill of Lading)
|
ZBILOFLAD (Bill of Lading)
|
4
|
LIKP_WADAT_IST (Actual Goods Movement Date)
|
0ACT_GI_DTE (Act.goods issue date)
|
5
|
LIPS_KVGR2_TXT (Customer Group2 Description)
|
0CUST_GRP2 (Customer group 2)
|
6
|
LIPS_LFIMG (Actual Qty Delivered)
|
ZDLV_QTEA (Delivery quantity EA)
|
7
|
LIPS_MEIN (Unit of Measure)
|
0SALES_UNIT (Sales unit)
|
8
|
LIPS_VBELN (Delivery Number)
|
0DELIV_NUMB (Delivery)
|
9
|
MARM_UMREN (Denomination for conversion to base unit of measure)
|
Not Required due to conversion in BW
|
10
|
BSTNK (Customer Purchase order number)
|
0PO_NUMBER (PO number)
|
11
|
KUNNR (Sold to party)
|
0SOLD_TO (Sold-to party)
|
12
|
VBELN (Sales Document)
|
0DOC_NUMBER (Sales document)
|
13
|
VDATU (Requested Delivery Date)
|
0AF_RQDATE (AFS Desired Del.Date)
|
14
|
BMENG (Confirmed Quantity)
|
ZCONFQTEA (Confirmed Qty in EA)
|
15
|
J_3ASIZE (Grid Value)
|
0AF_GRDVAL (Grid Value)
|
16
|
WMENG (Order Quantity in sales units)
|
ZORD_QTEA (Order quantity EA)
|
17
|
MATNR (Material Number)
|
0MATERIAL (Material)
|
18
|
POSNR (Sales Document Item)
|
0DOC_NUMBER (Sales document)
|
19
|
BEZEI (Description)
|
0SALES_GRP (Sales group)
|
20
|
SPRAS (Language Key)
|
Field Not Required
|
Issues
None